Overview: SQL Expressions

Use this operation to enter multiple SQL expressions that will be executed to create new fields in your dataset. The resulting dataset will contain all the original fields as well as the new values generated from the user defined SQL expression queries.

NOTE: CSense provides secure native blocks and operations for building analytics and solutions. The native capabilities provided by CSense can be extended by making use of this feature. When making use of this feature, please ensure that you have validated your extended functions to ensure that they perform as intended and do not introduce stability or security risks to your production system. Do not use scripts or components from untrusted sources.

Properties

Category:

Add

Performance risk:

Low performance risk

Knowledge required:

Working knowledge of SQL

 

Effect on datasets

How many datasets are required to perform this operation?

One

Does it create a new dataset?

No

Can you reconfigure this operation?

Yes

Can you apply this operation to a locked dataset?

No

Does it modify the current dataset in any way?

Yes

Requirements

  • This operation needs a dataset that contains at least one field.

Results

  • A modified dataset with the new fields containing the user-defined values produced from the queries.

  • The original fields will be unaffected by this operation. The dataset will however add the new fields (provided that there is enough space inside the dataset for the new fields) that contain the user-defined values.


Related topics:

  

CSense 2023- Last updated: November 17,2023